﻿-- =============================================
-- System Name:    Pre-Contract
-- Component:      Add new DicItems
-- Created By:     Leo Ren (leoren@wicresoft.com)
-- Created Date:   2011-5-30
-- =============================================
SET IDENTITY_INSERT [dbo].[DicItem] ON
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (30, 6, N'统谈统签', N'统谈统签', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (31, 6, N'统谈分签', N'统谈分签', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (32, 6, N'省内自签', N'省内自签', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (33, 7, N'全部转正', N'全部转正', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (34, 7, N'部分转正', N'部分转正', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (35, 7, N'取消(未发货)', N'取消(未发货)', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (36, 7, N'取消(可退货)', N'取消(可退货)', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (37, 7, N'取消(不退货)', N'取消(不退货)', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (38, 8, N'全部开票', N'全部开票', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (39, 8, N'部分开票', N'部分开票', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (40, 8, N'不能开票', N'不能开票', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (41, 8, N'澄清中', N'澄清中', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (42, 9, N'BP已同意', N'BP已同意', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (43, 9, N'BP未同意', N'BP未同意', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (44, 9, N'与BP沟通中', N'与BP沟通中', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (45, 10, N'用户原因', N'External', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (46, 10, N'公司内部原因', N'Internal', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (47, 10, N'双方履约争议', N'Contract/product dispute', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (51, 12, N'CDMA集采', N'CDMA集采', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (52, 12, N'WCDMA集采', N'WCDMA集采', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (53, 12, N'GSM集采', N'GSM集采', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (54, 12, N'FEMTO设备', N'FEMTO设备', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (55, 12, N'FEMTO设备', N'FEMTO设备', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (56, 12, N'IMS项目', N'IMS项目', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (57, 12, N'xPON', N'xPON', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (58, 12, N'Q-chat', N'Q-chat', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (59, 12, N'传输>0.3ME', N'传输>0.3ME', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (60, 11, N'用户无立项', N'Customer has no budget', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (61, 11, N'等采集价格', N'Pending central bid price', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (62, 11, N'用户流程中', N'In customer process', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (63, 11, N'用户需求变更', N'Customer requirement change', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (64, 11, N'用户人事机构调整', N'Customer personnel change', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (65, 11, N'定期结算', N'Term settlement', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (66, 11, N'其他', N'Other', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (67, 11, N'未齐套发货', N'Incomplete delivery', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (68, 11, N'价格待BP认可', N'Pending BD acceptance of pricing', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (69, 11, N'配置变更待BP认可', N'Pending BD acceptance of re-configuration', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (70, 11, N'其他', N'Other', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (71, 11, N'其他合同的执行问题', N'Contract execution issue', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (72, 11, N'未解决的产品技术障碍', N'Product & quality issue', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (73, 11, N'产品没有入围', N'Product not shortlisted', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (74, 11, N'商务条款争议', N'Commercial dispute', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (76, 13, N'PreContractType', N'类型-Category', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (77, 13, N'PreContractAdjust', N'分类-Adjust', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (78, 13, N'PreContractStatus', N'状态-Status', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (80, 13, N'BDCode', N'事业部-PU', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (81, 13, N'ContractName', N'合同名称-Contract Name', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (82, 13, N'ProductName', N'产品-Product', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (83, 13, N'ClusterCName', N'大区-Cluster', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (84, 13, N'ProvinceCName', N'省-Province', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (85, 13, N'CATCode', N'CAT', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (86, 13, N'CEWPromised', N'Cygnus承诺金额-Cygnus RMB', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (87, 13, N'SparePrice', N'Cygnus剩余金额-Cygnus Spare RMB', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (88, 13, N'OrionPrice', N'Orion RMB', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (89, 13, N'SalePrice', N'Cygnus最终金额-Sales RMB', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (90, 13, N'SignActual', N'最终转正时间-Final Date', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (91, 13, N'CEWME', N'Cygnus金额-Cygnus ME', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (92, 13, N'PromisedDate', N'Cygnus转正时间-Cygnus Date', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (93, 13, N'OrionME', N'Orion金额ME-Orion ME', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (94, 13, N'SignDue', N'Orion转正时间-Orion Date', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (95, 13, N'GAP', N'差额-GAP', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (96, 13, N'TradeMonth', N'预计转正月份-TradeMonth', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (97, 13, N'CFIPrice', N'库存金额-CFI', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (98, 13, N'ERPReceived', N'订单确认时间-ERP Accept', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (99, 13, N'SpecialApprove', N'终审选项-Final Approve Information', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (100, 13, N'ExistMonth', N'存在周期(月)-Accept Date', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (101, 13, N'DelayWeeks', N'逾期周数-Delay Weeks', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (102, 13, N'Delivered', N'到货状态-Delivered', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (103, 13, N'DeliveryPercent', N'发货率%-Delivery Percentage%', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (104, 13, N'DeliveryDate', N'发货时间-Delivery Date', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (105, 13, N'AOGDate', N'到货时间-AOG Date', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (106, 13, N'DeliveryPlan', N'发货预测-Delivery Plan', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (107, 13, N'UpdateReason', N'更新原因-Update Reason', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (108, 13, N'ACRNo', N'ACR编号-ACR No', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (109, 13, N'AdvancedContract', N'正式合同号-Advanced Contract', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (110, 13, N'CustomerName', N'客户名称-Customer Name', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (111, 13, N'OrionNo', N'Orion 编号-Orion No#', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (113, 13, N'Comments', N'备注-Comments', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (114, 13, N'BlackDate', N'黑名单时间-Black Date', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (115, 13, N'CommentPromisedDate', N'备注承诺转正时间-Comment Promised Date', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (116, 13, N'ProvinceCode', N'省份缩写-Prov', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (117, 13, N'Applicant', N'申请人-Apply Name', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (118, 13, N'ApplicantEmail', N'申请人邮件-Apply Mail', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (119, 13, N'Principal', N'项目负责人-Project Name', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (120, 13, N'PrincipalEmail', N'项目负责人邮件-Project Mail', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (121, 13, N'BGCode', N'BG', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (122, 13, N'IsDelay', N'是否是借/试等合同-Is Loan/Try', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (123, 13, N'IsRiskDesc', N'安全/风险-Secure/Risk', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (124, 13, N'ModifiedDate', N'修改时间-Modified', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (125, 13, N'TransferHistoryInfo', N'转正情况-Transfer Info', 1)
INSERT [dbo].[DicItem] ([DicItemID], [DicTypeID], [DicItemValue], [DicItemDesc], [IsEnabled]) VALUES (130, 14, N'http://localhost:50395/', N'预合同站点名称', 1)
SET IDENTITY_INSERT [dbo].[DicItem] OFF

